﻿CREATE TABLE [dbo].[Empresa] (
    [Id]        INT           IDENTITY (1, 1) NOT NULL,
    [Nombre]    VARCHAR (50)  NOT NULL,
    [Cedula]    VARCHAR (20)  NULL,
    [Direccion] VARCHAR (500) NULL,
    [Telefono]  VARCHAR (20)  NULL,
    [Fax]       VARCHAR (20)  NULL,
    [Email]     VARCHAR (50)  NULL,
    [Utilidad]  MONEY         NOT NULL,
    [ImpuestoVenta]  MONEY         NOT NULL,
    [Activo] BIT NOT NULL DEFAULT 0, 
	[PrecioMolde]         MONEY NOT NULL DEFAULT 0,
    [PrecioTinta]         MONEY NOT NULL DEFAULT 0,
    [PrecioPositivo]      MONEY NOT NULL DEFAULT 0,
    [PrecioArte]          MONEY NOT NULL DEFAULT 0,
    [PrecioSolvente]      MONEY NOT NULL DEFAULT 0,
    [PrecioCorte]         MONEY NOT NULL DEFAULT 0,
    [PrecioVelocidad]     MONEY NOT NULL DEFAULT 0,
    [PrecioHoraImpresion] MONEY NOT NULL DEFAULT 0,

    CONSTRAINT [PK_Empresa] PRIMARY KEY CLUSTERED ([Id] ASC),
);


GO

